package com.comum.javahomework420242025.repository;
import com.comum.javahomework420242025.pojo.KeyMan;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface KeyManRepository extends JpaRepository<KeyMan, Long> {
    @Query(value = "select * from keyman where clientcompanyid=:clientcompanyid and (" +
            "name like %:str% or boss like %:str% or " +
            "zhiwu like %:str% or isprime like %:str% or " +
            "comment like %:str%)",nativeQuery = true)
    List<KeyMan> selectByStr(String str, String clientcompanyid);
}
